play makAll work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All
HBAM2016AUG95
Pro 3.0
All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dullCopyright 1984-1996 Claris Corporation
and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy.
HBAM3016AUG95
Keith Proctor
Pro 3.0F!
Pro 3.0M1
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
Address
Go to Checking Account
Go to Contacts
Go to Dollar Amount English
Go to Due Invoices
Go to Invoices
Go to Job Application
Go to Letter
Go to Line Checks
Go to Line Items
Go to Line Items P.O.
Go to Timecards
Go to Main Menu
Go to Memorandum
Go to Messages
Go to Personnel Records
Go to Phone Numbers
Go to Products
Go to Purchase Orders
Go to To Do List
Go to Report Menu
Go to Reports in Contacts
Go to Reports in Invoices
Go to Reports in Parts
Print Help Documentation
Close File
Verify Password
7/6/99
COMPANY ADDRESS
COMPANY CITY
COMPANY LOGO DISABLED
COMPANY LOGO PLAIN
COMPANY NAME
COMPANY STATE
COMPANY ZIP CODE
COMPANY ZIP CODE BARCODE
DATABASE NAME
DOCUMENTATION
E MAIL ADDRESS
FAX LOGO
FAX NUMBER
LAYOUT NAME
LETTER BODY DISPLAY
LETTER CLOSE
LETTER GRAPHICS
LETTER HEAD DISPLAY
LETTER ID
LETTER LOGO PLAIN
LETTER SERIAL
LETTER TYPE
LOCAL LETTER ID
LOGO LOCATION
PASSWORD
PHONE NUMBER
PRINT CHOICE
REASON FOR LETTER
USER NAME
A User NameB
Company NameB
Company AddressB
Company CityB
Company StateB
Company Zip CodeB
Letter Logo PlainB
Company Logo PlainB
Company Logo DisabledB
Fax LogoB
Layout NameB
Database NameB
Letter SerialB
Reason for LetterB
A Letter IDB
Letter TypeB
Logo LocationB
Letter CloseB
Local Letter IDB
Macintosh 01 User
TO START USING THIS FILEMAKER DATABASE FILES.
1.- OPEN THE MAIN MENU FILE.
2.- CLICK ON THE HELP BUTTON WITHIN THE [MAIN MENU] FILE IN FILEMAKER FOR
INSTRUCTIONS AND INFORMATION.
3.- YOU CAN RETURN TO THE [MAIN MENU] FILE AT ANY TIME BY PRESSING [Apple] AND [1] THEN
CLICK ON THE HELP BUTTON WITHIN THE [MAIN MENU] FILE IN FILEMAKER FOR
INSTRUCTIONS AND INFORMATION.
Version History:
What's new on version 4.0?
* All included files have been modified for better display on 800
E [MAIN MENU] FILE IN FILEMAKER FOR
INSTRUCTIONS AND INFORMATION.
Version History:
What's new on version 4.0?
* All included files have been mod
Letter GraphicsB
Letter Head DisplayB
= "Top Left"
= "Top Center"
= "Top Right"
Top Left
Top Center
Top Right
Letter Body DisplayB
1) = "Block"
Block
DocumentationB
Print ChoiceB
Fax NumberB
Phone NumberB
E Mail AddressB
Company Zip Code BarcodeB
PasswordB
A Main Menu
Preferences 1
Documentation
Preferences 2
Preferences 3
Preferences 4
Print Documentation
Password
A Main MenuB
NRPTH
FPTHANDaffy:Desktop Folder:Franz Project:FM Pro Solution:6-More Changes:Invoices.FP3
MSPCA
NAMEA
Invoices.FP3
RPTHA
Invoices.FP3
NRPTH
FPTHANAPS Drive
:Projects:Franz Project:FM Pro Solution:13-More Changes:Contacts.FP3
al help layouts. Click on the help button in each file to see this general help.
ACTIVITY LOG
Description
Use this database to track messages and contacts with your customers. Th
sZJBBsZRsZ
R(kskccBJRJ9BJJB1BRZRZs{scRZsskRZk
{scJJZRBRccZJZskcckkZJ19JB9))1ZRZcZckZRJJRZs
{sZssks
kZcZcksk
{skZssk
kZcZZckk
Information
Call Entry
Enter notes about the phone call in the Notes field and select an appropriate Action Status and Action Type.
Letter Entry
To create a letter, type the contents of the letter in the Letter Contents field and click the Print Letter button to print a copy of the letter.
Fax Entry
To create a fax, type the contents of the fax message in the Fax Mes
fter entering the preferences on the taxes & deductions rates (percentages), you must create a report (handled from the Purchase Orders database file) in order to keep track of all the information such as Timecards, Paychecks, and taxes & deductions. To create such report go to the Purchase Orders file, create a new record, enter a Contact Number (Account Number from the Contacts file) on the Supplier No. field if you are in the Purchase Orders Form, if
"%UR
UD33D
ick on reports and click on [Make Paycheck] icon, or if you are in the Form view layout, simply select the script [Make Payroll (Payment) Check] from the Script menu. However there's one limitation on the Checking Account file. You must enter the check number manually because the script selects the Record Number field as the check number. After clicking or making the check and you want to print the check, just click on the [Print Check] icon from the Checking Account
1)1R99J119RkkskJJZccRR9
!)!!))!
1191))1BBJJB9BJ91
J1)19
1))11
1RRZRBZkss{{
scZRRJc
sc9)1BR91))1B
1RBBRR
BRRB11B
RRJBBJ1
1)1R99RJ119kkskJJZccZRR911
!)!!))!
1191))1
JB9BJ91
1RRZRBBZks{{
JccZcs
scR9)1B91))1B
RBBRR
RRJBBJB1
191BZB9
wwwwww
ffffff
UUUUUU
DDDDDD
333333
""""""
#11#22122"3!
"#""3"129
D@
D@
DDDDDD
wwwwww
wwwwww
ffffff
333333
""""""
wwwwww
DDDDDD
333333
%US31
%US30
#4EWp
"4EVx
#3EVg
"4DUg
#3EVg
"#4DVg
24EVgy
"34EVw
##4Efw
""3DUgw
""33DUfw
""34DVgx
""#34EVgx
"#33DEfw
" 234DUfw
2""2334DEVgx
3 4DEUfwx
3 DDUVgw
D EUUfwx
UDDEUUfgw
U Vfgwx
eUVfgww
wwffeffg@
veUEDDCC
vUTDD44
vUDDC32
#""#
weUDD3
veTDC2233#3#2
wUDDC3##"
vUTD3#22
vUDDC
fUD42233##3#"!
vTDCC##"
eUDC3223##
fTD4C3##23#""
uTDC3323#2""!
22"2"
##2"!
fTDD33#22""
vUDC32"2""
WUTC22
eTD3#""
GDC32"!!
eD3#"!
T32""
wwwwww
ffffff
UUUUUU
DDDDDD
333333
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
UTdUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
wwxwwxw
wwwwww
ffffff
UUUUUU
DDDDDD
333333
Preferences 1B
_>Main Menu - Click a button to access a database or preferences
Preferences
Activity Log
W Addresses
Contacts
Dollar Amount - English
Invoices
Job Application
Letters
Line PO Items
Memorandum
Messages
Phone Numbers
Products
To Do List
Click on any button to open that file and start working.
Click on the Info button for more information, help and shareware fee for this business solution database.
Click on any button to open that file and start working.
Click on the Info button for more information, help and shareware fee for this business solution database.
Files used for storage purposes
orTo return to this menu press [
] and [1] keys from any file,
or go to the script menu and select [Go to Main Menu]
Purchase Orders & Payroll
Checking Account
r Timecards
Line Checks
Line Items
DocumentationB
Preferences
Main
Address
Standard Letter
Miscellaneous
Company Name
Company Address
Company City
State
Company Zip
ypCompany Name and Address - enter your company address information as you would like to see it appear on letters.
Your Company Address
{ Your Name
|uUser Name - enter your name as you would like to see it appear on letters, invoices, and in contact history records.
<Letter Logo - paste a graphic into the Letter Logo field to add your own logo to the top of letters printed from the Integrated Solution. The Standard Letter preference panel has a Logo Location preference which can be used to display the letter logo at the top of a letter towards the left, center, or right margin.
Company Logo Plain - paste a graphic into this field to display your own logo at the top left corner of each of the Integrated Solution files.
Company Logo Disabled - paste a graphic into this field to display a disabled version of your logo at the top left corner of the Integrated Solution files when there is a custom dialog showing (eg. when no records are found).
Preferences
Preferences 4B
Preferences
Main
Letter Type
Logo Location
Letter Close
mmSelect a location for the logo at the left, center, or right side at the top of letters that will be printed.
,Select a letter style for the formatting of paragraphs in letters. Block letters do not use indents; whereas, modified style letters have a one tab indent at the beginning of each paragraph. Formal letters use the full name of the addressee; whereas, informal style letters use only the first name.
Select from 8 choices for a closing (or
complimentary close
) for letters; e.g.,
Respectfully yours,
Yours truly,
Best wishes,
etc.
Address
Standard Letter
Miscellaneous
Preferences
Print DocumentationB
_)BusinessAccounting Solution documentation
A!Integrated Solution documentation
Page ##
Preferences
Main
Miscellaneous
Standard Letter
Address
Tax Rate Option
Tax Rate Option - Enter the tax rate that should be used for calculating invoice totals. Values should be entered as a decimal such as .0825.
Tax Rate
Printing Options
Print Options - select an option for printing or previewing a report to control how reports are displayed. You can choose print only, preview only, or preview and then print.
Print Choice
Product ID Option
Product ID
{Product ID Option - Select the type of ID to be entered for a product when a new product record is created. Sequential Serial Number - a number that starts at 1 and is incremented by one. Text and Sequential Number will enter the first character of the first 3 words in the short description and a sequential number. Selecting None will allow you to enter your own Product ID.
Preferences
PasswordB
Please enter your password
click on the continue button
or press enter WHEN FINISH...
IF YOU
RE EXPERIENCing PROBLEMS DOING THIS REQUEST,
GO BACK TO THE ORIGINAL FILE AND TRY to do IT AGAIN.
PLEASE NOTE THAT ALL REQUESTS AND/OR TRANSACTIONS
ARE NOW BEING RECORDED, DON
T TRY TO OVERRIDE THE PROCEDURE,
the system will not accept unauthorized requests or transactions.
x 600 monitor resolutions. The used fonts are Geneva for Display on screen porpuses for printed forms Times & Helvetica, except the Invoices forms which uses other fonts.
* Main Menu: New button (Timecards) and script to open that file at the startup, such file is relational to Purchase Orders, Contacts, & Checking Account.
* Contacts: Better interface. Modifications of scripts and fields to handle payroll. (See layout Personal & Job Information).
* Invoices: New field (Payroll payment da
te) you can now modify the date on which you are supposed to pay the corresponding commission for a particular invoice. Better interface.
* Purchase Orders: Relational to the Timecards (NEW FILE) to keep track commissions, salary, overtime, hours worked, etc. (See description for Timecards)
* Timecards (NEW FILE): For control of payroll. Printed reports can be customized according to your company needs.
* Profit and Loss (NEW FILE): Scheduled for August 15, 1999.
What's new on version 3.0
Orders file to add any new items or products purchased.
* Pur
om the script menu.
All scripts are very clear to understand and each script perform what it's name says, or what it is supposed to do.
All the information on the fields is easy to enter since each field has its name or description either on top, bottom, right or left side of each field.
WE HOPE THIS INFORMATION ANSWER ALL YOUR QUESTIONS REGARDING THIS PROGRAM.
ALL REGISTERED USERS HAVE UNLIMITED FREE SUPPORT BY E-MAIL ONLY, SEND YOUR QUESTIONS TO: elsoldemex@aol.com
resent.
er the Contact Number on the Report Number field.
After creation of the report mentioned above you must create a Timecard, to do this, select the script (Create New Timecard) from the scripts file [Create one Timecard for each worked week]. If you create two Timecards with the same date, that information will be duplicated and calculations will be performed as two different weeks, so please be sure to create a single Timecard for each worked week.
To print a paycheck simply click on rep
orts and click on [Make Paycheck] icon, or if you are in the Form view layout, simply select the script [Make Payroll (Payment) Check] from the Script menu. However there's one limitation on the Checking Account file. You must enter the check number manually because the script selects the Record Number field as the check number. After clicking or making the check and you want to print the check, just click on the [Print Check] icon from the Checking Account file or select [Print Check] fr
urs directly into the database, or you can print blank Timecard reports for them to fill out and return.
The database calculates the hours worked based on the start time, lunch duration, and end time, as well as the employee's pay, based on the hours they worked and their pay rate, deducts taxes & withholdings according to the preferences in the Contacts file. It can also tracks vacation and sick time.
You enter preferences on the Contacts file by "Clicking" on the "Personal Info" butto
n. After entering the preferences on the taxes & deductions rates (percentages), you must create a report (handled from the Purchase Orders database file) in order to keep track of all the information such as Timecards, Paychecks, and taxes & deductions. To create such report go to the Purchase Orders file, create a new record, enter a Contact Number (Account Number from the Contacts file) on the Supplier No. field if you are in the Purchase Orders Form, if you are in the Payroll Form ent
rmation
Supplier Number
Type in a contact ID from the Contacts database. Company name and address is obtained from the Contacts database.
Bill to Account No.
There
s a trick to make it work. Instead of typing a first name in the Contacts database, enter the account number you have with the vendor, such as credit card number.
The box at the bottom right corner of the layout
This space shows the checks made to this company to pay this purchase order.
Everytime you want to make a payment for
a particular purchase order, select Make Check/Payment from the scripts menu. To print a purchase order or print insertion order. Click on the reports icon and select the corresponding form. Please note that any items purchased or ordered from this file will modify the available quantity in the Products database.
TIME CARDS
Description
This database keeps track of employee hours, and is based on the standard employee timecard.
How to use this solution
Your employees can enter their ho
uct that you sell. Information on product price and description is looked up in the Invoices database based on the Product ID.
Entering information
Product Information
Enter the product type, a short description, long description, short description in Spanish, the cost, the selling price, other charges cost such as fee for a returned check and the unit weight of the product.
General Comments
Enter any notes on the product here.
Vendor Information
Type in a contact ID from the Contacts d
atabase in the Vendor ID field. Company name and address is obtained from the Contacts database.
Inventory
Type in the necessary information. Note that this file is now relational to the Purchase Orders database and the available quantity is updated if more products from the same items have been purchased or ordered from the Purchase Orders database.
PURCHASE ORDERS
Description
Use the Purchase Orders database to create purchase orders for items or products you buy and sell.
Entering info
are always entered from the Contacts database but are stored in this file to allow for an unlimited number of contact phone numbers.
TO ENTER A PHONE NUMBER
- Go to the Contacts database and find or create a contact record.
- Type a phone number into the first available space in the phone number list.
A new phone number record will be created and stored in the Phone Numbers database. Because the Phone Numbers database is related to Contacts, all phone numbers for a particular person can
be viewed from the Contacts database.
How to customize this solution
To change or add to the values for the Phone Number Location field, go to the Contacts database and edit the value list there.
PRODUCTS
Description
Use the Products database to enter information on products or services that you sell. This product information is used by the Invoices database to look up prices and product descriptions when creating a customer invoice.
How to use this solution
Enter a record for each prod
racter of the first 3 words in the short description and a sequential number. Selecting None will allow you to enter your own Product ID.
How to customize this solution
Add your own buttons to the main menu layout to open other databases that you use.
MEMORANDUM
No further description or instructions are needed. :-)
MESSAGES
No further description or instructions are needed. :-)
PHONE NUMBERS
This database file is used by the file Contacts to store phone numbers.
To enter a phone numbe
r for a Contact, open the Contacts database and type the phone number there.
PHONE NUMBERS
Description
This file is used to track customer phone numbers and is related to the Contacts database. Having a separate database for phone numbers allows you to store as many different types of phone numbers as you need to reach someone. For instance, you can store phone numbers for work, home, school, mobile, and other locations as well as internet addresses.
How to use this solution
Phone numbers
one tab indent at the beginning of each paragraph. Formal letters use the full name of the addressee whereas informal style letters use only the first name.
Letter Close
Select from one of seven choices for a default closing statement for letters such as
Respectfully Yours
Your Truly
Best Wishes
, etc.
Miscellaneous
Printing Options
Select an option for printing or previewing a report to control how reports are displayed. You can choose print only, preview only, or preview and then
print.
Tax Rate
Enter the tax rate that should be used for calculating invoice totals. Values should be entered as a decimal such as .0825. Most of other files (e.g. invoices) uses their own tax rate which can be specified as .0825 but will be displayed as 8.25%.
Product ID
Select the type of ID to be entered for a product when a new product record is created. Sequential Serial Number - a number that starts at 1 and is incremented by one. Text and Sequential Number will enter the first cha
Logo field to add your own logo to the top of letters printed from the Integrated Solution. The Logo Location preference can be used to display the letter logo at the top of a letter towards the left, center, or right margin.
Company Logo Plain
Paste a graphic into this field to display your own logo at the top left corner of each of the Integrated Solution files.
Company Logo Disabled
Paste a graphic into this field to display a disabled version of your logo at the top left corner of th
e Integrated Solution files when there is a custom dialog showing (e.g. when no records are found).
Standard Letter
Logo Location
Select a default location for the Letter Logo at the left, center, or right side at the top of letters printed from the Integrated Solution.
Letter Type
Select a default letter style for the formatting of paragraphs in letters. Four choices are available: block/modified and formal/informal. Block letters do not use indents whereas modified style letters have a
e items for a particular invoice can be viewed from the Invoices database.
LINE PO ITEMS
Description
This database file is used by the Purchase Orders database to store items purchased. To enter an item for a product purchase, open the Purchase Orders database and type the required information.
MAIN MENU
Description
Use the Main Menu database to navigate to the solution files and set general preferences.
How to use this solution
To set preferences for solution files.
- Click on the Pref
erences button.
- You can enter your address, a company logo, or set the default style for creating new letters.
Address
User Name
Enter your name as you would like to see it appear on letters, invoices, fax cover sheets, statements and all related printed forms.
Company Name and Address
Enter your company address information as you would like to see it appear on letters, invoices, fax cover sheets, statements and all related printed form.
Logos
Letter Logo
Paste a graphic into the Letter
ters database is related to the Activity Log database, all letters for a particular contact can be viewed from the Contacts database.
LINE CHECKS
Description
This database file is used by the Checking Account database to store payments made to a contact. To enter a check line for a check number, open the Checking Account database and type check number.
LINE ITEMS
Description
The Line Items database is used to track individual items purchased by a customer and is related to the Invoices d
atabase.
How to use this solution
Line items are always entered from the Invoices database but are stored in this file to allow for an unlimited number of items to be purchased.
TO ENTER A LINE ITEM
- Go to the Invoices database and find or create an invoice record.
- Type a product ID into the first available row in the list of products purchased.
A new line item record will be created and stored in the Line Items database. Because the Line Items database is related to Invoices, all lin
cture to the layout. For details on importing a picture, see the FileMaker Pro documentation.
Modify the value list for the skills listed on the Skills layout. In Layout mode, select the Skills field in the Skills layout and choose Field Format
from the Format menu. In the pop-up menu after "using value list", select Define Value Lists
. Edit the list of skills to match those you are seeking.
LETTERS
Description
Use this database to write letters to send to people in the Contacts databas
How to use this solution
Letters are always entered from the Activity Log database but are stored in this file to allow for an unlimited number of letters.
TO ENTER A LETTER
- Go to the Contacts database and find or create the contact record.
- Create an activity by clicking on the New Activity button under Action History.
- Click on the Letter button and type the letter you wish to send.
This letter will be stored in the Letters database and is logged as an activity. Because the Let
ice (button): Everytime you click on this button it will print the corresponding form according to invoice days old, amount due, etc. To print statements or another form select the corresponding script from the scripts menu.
How to customize this solution
Change or add to the values in the pop-up lists for Carrier, Shipping Priority, Payment Method, and Credit Card Type.
JOB APPLICATION
Description
Use this form to collect standard applicant information. The form contains fields for an ap
plicant's skills, education, experience, personal information, and references. Simply print the form and use as needed.
How to use this solution
Enter the data from the application form into the database file. You can then search the file to identify all candidates who match specific job criteria.
How to customize this solution
You can modify the form's layout to duplicate your own employee application form. Add your company logo to the Job Application report by copying or importing a pi
Shipping Information
Click on the icon for shipping details to enter information such as the shipment location, cost, weight, carrier type, priority, and tracking number.
Products Purchased
Type in a product ID from the Products database in the first available row. Or click on the Find Product to activate a script to find a specific product. After you find the correct product, click on the (Select this Product) button on the right top part of the layout. Product price and description
s are automatically looked up from the Products database. Also enter the quantity of product purchased. Because each product purchased is stored in the Line Items database, you can enter as many products as needed for an invoice by typing a new product ID in the first available space in the list. To view additional products purchased for an invoice, click on the scroll bar to the right of the products list.
All remaining fields: No further information or instructions needed. :-)
Print Invo
Description
Use this file to create and keep track of invoices for your customers. The Invoices database allows you to bill a customer for products or services they have purchased. Product information is looked up from the Products database and customer information is obtained from the Contacts database, and each item purchased is stored in a file called Line Items. The Invoices database ties all this information into a single form which you can print as invoice, invoice past due, sta
tement, etc. You can select what kind of form to print from the script menu, or click on the Print Invoice icon, the corresponding form will be printed automatically.
How to use this solution
Buttons
No further information or instructions needed. :-)
ENTERING INFORMATION
Purchaser Information
Type in a contact ID from the Contacts database or click on top of the Account Number field to activate the script/button. Company name, address, phone number, etc. is obtained from the Contacts datab
utomatically from the Invoices database.
Available Credit: Calculated automatically from the Invoices database.
Total Purchases: Calculated automatically from the Invoices database. Please note that this amount is for the orders already paid, this field does not count the unpaid invoices or orders.
How to customize this solution
If the built-in label report does not match the labels you use, edit the existing layout or create a new layout. Choose Layout from the Select menu. Select New Lay
out from the Edit menu, click the Labels radio button and choose the proper Avery label in the menu. For details on formatting a label layout, see the FileMaker Pro documentation.
Change or add to the values in the pop-up lists for Contact Priority, Type, Phone Number Locations, or Personal Title.
DOLLAR AMOUNT - ENGLISH
Description
This database file is used by the file Checking Account to create amount in words (English). The actual amount in English words are stored in this file.
his account.
Sales Representative Name: Automatically calculated after a valid value is entered in the sales representative number.
Commission Rate: Enter the percentage for commission rate for this sales representative.
(type the number as a decimal e.g. for 8.25% type 0.825)
Total Commission: Calculated automatically from the Invoices database.
Amount due by Sales Representative: Calculated automatically from the Invoices database.
Language for Invoices: Select the language in which you
want your invoices to be printed and send to this account. (there are currently two options: English and Spanish).
Authorized by: Type the name of the person who authorized or open this account.
Payment Terms: Select the payment terms from the pop-up list or type a new value.
No. of Ret. Checks: This field keeps track of any returned (bounced) checks from the Invoices database.
Credit Limit: Type the credit limit you want to assign for this contact.
Total Amount due by Client: Calculated a
tivity Log database, you can enter as many activities as needed for any contact. To view additional activities for a contact, click on the scroll bar to the right of the activity list.
FIELDS LOCATED AT THE BOTTOM OF THIS LAYOUT
Kind of Account, Contact Type, Priority, Referred by, Classification | Kind of Business, Included for Mail?, List Share?, Distribution?.
BLACK BACKGROUND WHITE LETTERS FIELDS
If your primary business is a newspaper, or magazine, or any other kind of subscription, t
his is good for your business.
Newspr. to Send: Enter the number of newspaper or magazines that you want to send to this contact.
Start | End Issue No: Left field: Start - Right field: End.
Sent | Remaining: Left field: Sent - Right field: Remaining.
FINANCIAL INFORMATION
No further information or instructions needed. :-)
OPEN ACCOUNT AND CREDIT INFORMATION
Sales Representative Number: Enter an account number from the Contacts database to select that contact as a sales representative for t
are password protected, just to mention some of them are Sales Representative Number, Commission Rate, Payment Terms, Credit Limit.
Entering Information
CONTACT INFORMATION
Enter the company name, contact name and address for a contact.
PHONE | FAX | INTERNET
Type in phone numbers to reach a contact, select from the list of locations such as home, work, or school, and type the times at which the contact can be reached. You can enter as many phone numbers as needed for any contact by typin
g a new phone number in the last available space next to the phone icon. Clicking the phone icon will use your modem or speaker to dial the phone number.
ACTION HISTORY
Click on any activity in the list to view all the information for that activity. To enter a new activity for the current contact, click on the small button. An activity is a type of correspondence that should be performed for the current contact such as a phone call, fax, or letter. Because each activity is stored in the Ac
rent user name as you have entered it in the preferences of FileMaker.
Select Acc for P.O.: Click on this button to select this account for a purchase order you are currently working on. Use this script if you are sure you are on the correct purchase order in the Purchase Orders database. Otherwise it will replace the account number and information to a purchase order already made.
Find: To enter find mode.
Reports: Use it to select reports to be printed such as envelopes, labels, etc.
rform Calculation: Click on this button to perform the calculation for the sales representative account status.
Phone Icon: Clicking the phone icon will use your modem or speaker to dial the phone number and keep track of that phone call.
Action History Icon: Click on this icon to create a new activity such as letter, fax or phone call or to see the activity listed next to the icon (if available).
There are a few hidden buttons (scripts performed when you click on a field) on this file and
your find criteria to see any specific invoice.
Go to Invoices | Acc: Click on this button to go to the Invoices database. By clicking on this button you will see the invoices made to this account as a list. Select the invoice you would like to see from that list.
Go to Main Menu: Clicking on this button will go to the Main Menu database, you can also select this script from the scripts menu or by pressing [Apple] and [1] from any database file.
Enter Notes: Click on this button to enter s
taff notes, such notes will appear on the [General Staff Notes & Credit References] field.
Select Acc for Inv.: Click on this button to select this account for an invoice you are currently working on. Use this script if you are sure you are on the correct invoice in the Invoices database. Otherwise it will replace the account number and information to an invoice already made. For security purposes and obvious reasons, this script is password protected, the password to be entered is the cur
on from any layout on this file to go to the data entry layout.
View as List: Click on this button from any layout on this file to see your contacts in list view.
Sales Rep. Info: Click on this button from any layout on this file to see the sales representative (not the contact) information so you can enter important information about your sales representative such as emergency contact, emergency number, social security, select salary, etc.
Personal Info: Click on this button to see the pe
rsonal information for this contact, by clicking on this button you will see the same layout as the Sales Rep. Info, but instead of going to the assigned sales representative information it will take you to the current contact information.
Go to Invoices: Click on this button from any layout on this file to go to the Invoices database. Please note that if no invoices have been made for this contact, it will show the Invoices database with no records present. Select find all records or use
ns are permitted until a valid value is given to the Transaction number field.
If you haven
t enter a contact information on the Contacts database, use the second field to enter that information manually and be able to print the checks. Always use the print check button to print a check, since the print button includes a script to calculate the amount paid and convert such amount to words in English.
CONTACTS
Description
Use this file to keep track of people you need to contact such as c
ustomers. The Contacts database contains information such as a customer
s name, phone number, address and many more options such as contact type, open account information (if you intend to open an account for a contact). Please note that this file works along with other related databases such as addresses, phone numbers, etc. The file includes predefined reports for printing customer profiles, phone lists, and mailing labels.
How to use this solution
Buttons
Data Entry: Click on this butt
ment for a related purchase order. The easiest way to make a check for a specific purchase order is going to the Purchase Orders database and select make check/payment from the scripts menu.
Payer Number (Account/Contact)
This field is used to get the information from the Contacts database, such as company name, address, etc. If you select the script on the Purchase Orders database, the account number will appear automatically or if you have asigned a value to the purchase order number. Ho
wever if the payment is not for a related purchase order you can type an account number from the Contacts database, by doing so the correct company, contact, address, etc. will be obtained from the Contacts database. You can also make checks payable to others not related to the Contacts or Purchase Orders database by typing the corresponding information in the available fields.
Transaction or Check Number
Type your check or reference number on this field, no descriptions of the transactio
ax button to print a copy of the fax.
ADDRESSES
Description
This file is related to Contacts and stores the information about address, company name, contact name and zip code, it is also used to generate bar codes for all correspondence that will be printed and keeps track of modified, date time, field name, and user who modified the field values.
CHECKING ACCOUNT
Description
This file is related to Contacts and Purchase Orders databases and is used to keep track of all your checking ac
count transactions such as deposits, cash withdrawals, checks paid, fees, etc.
Entering Information
Purchase Order
You can type a purchase order number in this field if the payment/check is for a purchase order. By doing so you will see a list of the checks made for a specific purchase order in the Purchase Orders database, the Purchase Orders database will calculate the amount due for that P.O. if payments have been made by check. The purchase order number is useful only when making a pay
ts database.
How to use this solution
Anytime you wish to track correspondence with a contact, go to the Contacts database, find a contact, and click the New Activity button. Choose which type of action to take: a call, letter, or fax. Click OK and enter the information for the call, the contents of the letter, or the message for the fax.
Note that much of the work of entering your address and the customer
s address has already been done. You can edit your address information in the Main
Menu preferences. The customer
s information is taken from the Contacts database.
Entering Information
Call Entry
Enter notes about the phone call in the Notes field and select an appropriate Action Status and Action Type.
Letter Entry
To create a letter, type the contents of the letter in the Letter Contents field and click the Print Letter button to print a copy of the letter.
Fax Entry
To create a fax, type the contents of the fax message in the Fax Message field and click the Print F
ntact I.D. or Account Number, you must type the account number from the Contacts database. Some scripts requires a password to complete the transaction, the password to be used is the current user name [not the password used to unlock the program]. The reason for this security step is to avoid cancellation of invoices, accounts closed, credit limit increases, etc.
Below you will find the documentation for each of the files included in this relational solution (alfabetically sorted). You ma
y find that this solution will work as is, but you may wish to make changes to customize this solution for your business. Either way this documentation is included to help you use this solution. You will find that some of this documentation can be found in some of the files on special help layouts. Click on the help button in each file to see this general help.
ACTIVITY LOG
Description
Use this database to track messages and contacts with your customers. This file is related to the Contac
to keep track of checking account, and print laser checks (Checking Account database performs a script related to Dollar Amount-English database to create the dollar amount in words [English only]). It is also used to keep track of purchase orders and payments.
(3) This files are not needed for this business solution, some of them are included with the FileMaker Pro Version 3.0 and later. The shareware fee is for the rest of the files.
Please note that in any field named Contact No. or Co
If you pay via check, it must be a check drawn in US Dollars.
Payments send via postal mail take time to reach us, and then up to 10 days for processing. Again, if you include a correct e-mail address, you will hear from us when the order is processed. And we will send you the password so you can adapt any scripts, fields or printed form from this Integrated Solution Database.
Please include with your payment: your company name, contact name, address, phone & fax number and e-mail ad
dress. Your password will be sent to you by e-mail and first class mail along with your payment receipt.
To report any bugs or have questions before paying the shareware fee:
While we hope you don
t find any bugs, if you do let us know!
The more information you can include the more likely we are to be able to fix it. Report any bugs or send comments and question by e-mail to: elsoldemex@aol.com or by fax at: (718) 460-3106.
Want more information?
Visit our web page at:
http://members.aol
************************************
This business solution is shareware. After paying the corresponding fee, you are allowed to modify it in any form to adapt it to your company needs, but you are not authorized to sell it or distribute it, except a password protected version with all the documentation.
This preview version is fully functional, but without a password you won
t be able to modify any scripts, fields, or printed forms on some files (files marked with an (*) below).
A sin
gle user license $100.00 per user.
A site license costs $500.00 and covers a building.
A world-wide license costs $800.00 and it covers all locations for your organization.
After paying the shareware fee all future updates will be free of charge, the new password to unlock any new version will be sent to you by e-mail.
How to Pay:
Mail:
If you are paying with USD Check or Money Order you should send it to:
EL SOL DE MEXICO
132-31 59TH AVENUE, 1ST FLOOR
FLUSHING, NY 11355-5242
the Products file to keep track of the open to buy products or items. It now doesn't allow to purchase products or items if the open to buy level is higher than the products planed to purchase.
(1) Reverts the credit limit to $0.00 not allowing future unpaid orders.
What's new on version 2.0?
Contacts and Invoices:
* Validates credit card numbers. It doesn't tell you whether the credit card has cleared the bank, but rather serves as a way to prevent typos. The algorithm is able to determi
ne if the digits in the card follow the correct pattern. If the credit card number is invalid it will show a red note below the credit card number field as: "Credit Card Number: INVALID". If the credit card number entered is correct it will only display "Credit Card Number" in black type.
* Print total number of pages in a statement. (i.e. PAGE 1 OF 15).
* All calculations are faster than any previous version.
* Most of the scripts have been "tuned up" for speed.
*************************
* Main Menu: New button (Line PO Items) and script to open that file at the startup, such file is relational to Products and Purchase Orders.
* Contacts: Better interface, minor bugs corrected for Y2K compliance, scripts have been modified to allow the user to cancel any transaction/script that needs password verification, the age field is not automatically calculated it now has a script/button defined to calculate only when needed.
* Invoices: Scripts have been modified to allow the use
r to cancel any transaction/script that needs password verification, minor bugs corrected for Y2K compliance, some minor changes in the interface and printed forms.
* Contacts and Invoices: keeps track of returned checks unpaid (bounced checks) and close(1) an open account automatically if three or more bounced checks are received in the same account.
* Products: Now its relational to the Purchase Orders file to add any new items or products purchased.